|
500
|
How can I filter items for dates before a specified date
Tree1->BeginUpdate();
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Dates");
var_Column->SortType = Extreelib_tlb::SortTypeEnum::SortDate;
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = true;
var_Column->DisplayFilterDate = true;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowFocusItem | Extreelib_tlb::FilterListEnum::exNoItems;
var_Column->Filter = L"to 12/27/2010";
var_Column->FilterType = Extreelib_tlb::FilterTypeEnum::exDate;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2010,12,27).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,28).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,29).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,30).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,31).operator double()));
Tree1->ApplyFilter();
Tree1->EndUpdate();
|
|
499
|
Is it possible to filter dates
Tree1->BeginUpdate();
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Dates");
var_Column->SortType = Extreelib_tlb::SortTypeEnum::SortDate;
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = true;
var_Column->DisplayFilterDate = true;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowFocusItem | Extreelib_tlb::FilterListEnum::exNoItems;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2010,12,27).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,28).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,29).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,30).operator double()));
var_Items->AddItem(TVariant(TDateTime(2010,12,31).operator double()));
Tree1->EndUpdate();
|
|
498
|
Is it possible to change the Exclude field name to something different, in the drop down filter window
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Description[Extreelib_tlb::DescriptionTypeEnum::exFilterBarExclude] = L"Leaving out";
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = false;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowExclude | Extreelib_tlb::FilterListEnum::exShowFocusItem | Extreelib_tlb::FilterListEnum::exShowCheckBox;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
Tree1->EndUpdate();
|
|
497
|
How can I display the Exclude field in the drop down filter window
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = false;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowExclude | Extreelib_tlb::FilterListEnum::exShowFocusItem | Extreelib_tlb::FilterListEnum::exShowCheckBox;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
Tree1->EndUpdate();
|
|
496
|
Is it possible to show and ensure the focused item from the control, in the drop down filter window
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = false;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowFocusItem | Extreelib_tlb::FilterListEnum::exShowCheckBox;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->set_SelectItem(var_Items->InsertItem(h,TNoParam(),TVariant("Child 2")),true);
var_Items->set_ExpandItem(h,true);
Tree1->EndUpdate();
|
|
495
|
Is it possible to show only blanks items with no listed items from the control
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = false;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowBlanks | Extreelib_tlb::FilterListEnum::exNoItems;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
Tree1->EndUpdate();
|
|
494
|
How can I include the blanks items in the drop down filter window
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = false;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowBlanks | Extreelib_tlb::FilterListEnum::exShowCheckBox;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
Tree1->EndUpdate();
|
|
493
|
How can I select multiple items in the drop down filter window, using check-boxes
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = false;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exShowCheckBox;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
Tree1->EndUpdate();
|
|
492
|
Is it possible to allow a single item being selected in the drop down filter window
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = false;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exSingleSel;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
Tree1->EndUpdate();
|
|
491
|
How can I display no (All) item in the drop down filter window
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Description[Extreelib_tlb::DescriptionTypeEnum::exFilterBarAll] = L"";
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = true;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exNoItems;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
Tree1->EndUpdate();
|
|
490
|
Is it possible to display no items in the drop down filter window, so only the pattern is visible
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Items");
var_Column->DisplayFilterButton = true;
var_Column->DisplayFilterPattern = true;
var_Column->FilterList = Extreelib_tlb::FilterListEnum::exNoItems;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
Tree1->EndUpdate();
|
|
489
|
How do I hide the selection
Tree1->BeginUpdate();
Tree1->MarkSearchColumn = false;
Tree1->SelForeColor = Tree1->ForeColor;
Tree1->SelBackColor = Tree1->BackColor;
Tree1->ShowFocusRect = false;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
Extreelib_tlb::IColumnPtr var_Column = var_Columns->Add(L"Format");
var_Column->FormatColumn = TVariant(String("type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=00") +
"00FF>+'+(value format '2|.|3|,' ): '0.00') )");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellCaptionFormat,TVariant(1));
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(10));
var_Items->AddItem(TVariant(-8));
Tree1->EndUpdate();
|
|
488
|
How do I access the cells, or how do I get the values in the columns
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"C1");
var_Columns->Add(L"C2");
var_Columns->Add(L"C3");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Item 1"));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant("SubItem 1.1"));
var_Items->set_CellCaption(TVariant(h),TVariant(2),TVariant("SubItem 1.2"));
OutputDebugString( PChar(var_Items->get_CellCaption(TVariant(h),TVariant(0))) );
|
|
487
|
Is it possible to load child items when clicking the +/- button
// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
void __fastcall TForm1::Tree1BeforeExpandItem(TObject *Sender,Extreelib_tlb::HITEM Item,Variant * Cancel)
{
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->InsertItem(Item,TNoParam(),TVariant("new"));
var_Items->set_ItemHasChildren(var_Items->InsertItem(Item,TNoParam(),TVariant("new")),true);
var_Items->InsertItem(Item,TNoParam(),TVariant("new"));
}
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->set_ItemHasChildren(var_Items->AddItem(TVariant("aka")),true);
var_Items->AddItem(TVariant("next item"));
|
|
486
|
How can I change the check-boxes appearance
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Default");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellHasCheckBox,TVariant(true));
var_Column->PartialCheck = true;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
Extreelib_tlb::IAppearancePtr var_Appearance = Tree1->VisualAppearance;
var_Appearance->Add(1,TVariant("XP:Button 3 12"));
var_Appearance->Add(2,TVariant("XP:Button 3 11"));
var_Appearance->Add(3,TVariant("XP:Button 3 10"));
Tree1->CheckImage[Extreelib_tlb::CheckStateEnum::Unchecked] = 16777216;
Tree1->CheckImage[Extreelib_tlb::CheckStateEnum::Checked] = 33554432;
Tree1->CheckImage[Extreelib_tlb::CheckStateEnum::PartialChecked] = 50331648;
|
|
485
|
How can I initiate the OLE Drag and Drop support
// OLEStartDrag event - Occurs when the OLEDrag method is called.
void __fastcall TForm1::Tree1OLEStartDrag(TObject *Sender,Extreelib_tlb::IExDataObject *Data,long * AllowedEffects)
{
// Data.SetData("data to drag")
AllowedEffects = 1;
}
Tree1->OLEDropMode = Extreelib_tlb::exOLEDropModeEnum::exOLEDropManual;
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
|
|
484
|
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
Tree1->BeginUpdate();
Extreelib_tlb::IConditionalFormatPtr var_ConditionalFormat = Tree1->ConditionalFormats->Add(L"1",TVariant("K1"));
var_ConditionalFormat->BackColor = RGB(255,0,0);
var_ConditionalFormat->ApplyTo = Extreelib_tlb::FormatApplyToEnum(0x1);
Extreelib_tlb::IConditionalFormatPtr var_ConditionalFormat1 = Tree1->ConditionalFormats->Add(L"1",TVariant("K2"));
var_ConditionalFormat1->BackColor = RGB(255,0,0);
var_ConditionalFormat1->ApplyTo = Extreelib_tlb::FormatApplyToEnum(0x2);
Tree1->MarkSearchColumn = false;
Tree1->DrawGridLines = Extreelib_tlb::GridLinesEnum::exRowLines;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Column 1");
var_Columns->Add(L"Column 2");
var_Columns->Add(L"Column 3");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TNoParam());
var_Items->AddItem(TNoParam());
var_Items->AddItem(TNoParam());
Tree1->EndUpdate();
|
|
483
|
Is it possible to display empty strings for 0 values
Tree1->Columns->Add(L"Currency")->FormatColumn = L"dbl(value) ? currency(dbl(value)) : ``";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(1.23));
var_Items->AddItem(TVariant(2.34));
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(10000.99));
|
|
482
|
Is it possible to display empty strings for 0 values
Tree1->Columns->Add(L"Number");
Tree1->Columns->Add(L"Currency")->ComputedField = L"%0 ? currency(%0) : ``";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(1.23));
var_Items->AddItem(TVariant(2.34));
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(10000.99));
|
|
481
|
How can I get the list of items as they are displayed
Tree1->BeginUpdate();
Tree1->BackColorAlternate = RGB(240,240,240);
Tree1->Columns->Add(L"Names");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("Mantel"));
var_Items->AddItem(TVariant("Mechanik"));
var_Items->AddItem(TVariant("Motor"));
var_Items->AddItem(TVariant("Murks"));
var_Items->AddItem(TVariant("Märchen"));
var_Items->AddItem(TVariant("Möhren"));
var_Items->AddItem(TVariant("Mühle"));
Tree1->Columns->get_Item(TVariant(0))->SortOrder = Extreelib_tlb::SortOrderEnum::SortAscending;
Tree1->EndUpdate();
OutputDebugString( PChar(Tree1->GetItems(TVariant(1))) );
|
|
480
|
Is posible to reduce the size of the picture to be shown in the column's caption
Tree1->BeginUpdate();
Tree1->HTMLPicture[L"pic1"] = TVariant("c:\\exontrol\\images\\zipdisk.gif");
Tree1->HeaderHeight = 48;
Tree1->Columns->Add(L"DefaultSize")->HTMLCaption = L"Default-Size <img>pic1</img> Picture";
Tree1->Columns->Add(L"CustomSize")->HTMLCaption = L"Custom-Size <img>pic1:16</img> Picture";
Tree1->EndUpdate();
|
|
479
|
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
Tree1->BeginUpdate();
Tree1->MarkSearchColumn = false;
Extreelib_tlb::IConditionalFormatPtr var_ConditionalFormat = Tree1->ConditionalFormats->Add(L"1",TNoParam());
var_ConditionalFormat->Bold = true;
var_ConditionalFormat->ForeColor = RGB(255,0,0);
var_ConditionalFormat->ApplyTo = Extreelib_tlb::FormatApplyToEnum(0x1);
Tree1->Columns->Add(L"C1");
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"C2");
var_Column->HeaderBold = true;
var_Column->HTMLCaption = L"<fgcolor=FF0000>C2";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(10))),TVariant(1),TVariant(11));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(12))),TVariant(1),TVariant(13));
Tree1->EndUpdate();
|
|
478
|
The item is not getting selected when clicking the cell's checkbox. What should I do
// CellStateChanged event - Fired after cell's state has been changed.
void __fastcall TForm1::Tree1CellStateChanged(TObject *Sender,Extreelib_tlb::HITEM Item,long ColIndex)
{
Tree1->Items->set_SelectItem(Item,true);
}
Tree1->Columns->Add(L"Check")->set_Def(Extreelib_tlb::DefColumnEnum::exCellHasCheckBox,TVariant(true));
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(1));
var_Items->AddItem(TVariant(2));
var_Items->AddItem(TVariant(3));
|
|
477
|
Is it possible to limit the height of the item while resizing
// AddItem event - Occurs after a new Item has been inserted to Items collection.
void __fastcall TForm1::Tree1AddItem(TObject *Sender,Extreelib_tlb::HITEM Item)
{
Tree1->Items->set_ItemMinHeight(Item,18);
Tree1->Items->set_ItemMaxHeight(Item,72);
}
Tree1->BeginUpdate();
Tree1->ItemsAllowSizing = Extreelib_tlb::ItemsAllowSizingEnum::exResizeItem;
Tree1->ScrollBySingleLine = false;
Tree1->BackColorAlternate = RGB(240,240,240);
Tree1->Columns->Add(L"Names");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("Mantel"));
var_Items->AddItem(TVariant("Mechanik"));
var_Items->AddItem(TVariant("Motor"));
var_Items->AddItem(TVariant("Murks"));
var_Items->AddItem(TVariant("Märchen"));
var_Items->AddItem(TVariant("Möhren"));
var_Items->AddItem(TVariant("Mühle"));
Tree1->Columns->get_Item(TVariant(0))->SortOrder = Extreelib_tlb::SortOrderEnum::SortAscending;
Tree1->EndUpdate();
|
|
476
|
Is it possible to copy the hierarchy of the control using the GetItems method
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Def");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
Tree1->PutItems(Tree1->GetItems(TVariant(-1)),TNoParam());
|
|
475
|
How can I show the child items with no identation
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exGroupLinesOutside;
Tree1->Indent = 12;
Tree1->HasLines = Extreelib_tlb::HierarchyLineEnum::exThinLine;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
|
|
474
|
Is there other ways of showing the hierarchy lines (exGroupLinesAtRoot)
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exGroupLinesAtRoot;
Tree1->Indent = 12;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
|
|
473
|
Is there other ways of showing the hierarchy lines (exGroupLinesOutside)
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exGroupLinesOutside;
Tree1->Indent = 12;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
|
|
472
|
Is there other ways of showing the hierarchy lines (exGroupLinesInsideLeaf)
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exGroupLinesInsideLeaf;
Tree1->Indent = 12;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
|
|
471
|
Is there other ways of showing the hierarchy lines (exGroupLinesInside)
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exGroupLinesInside;
Tree1->Indent = 12;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
|
|
470
|
Is there other ways of showing the hierarchy lines (exGroupLines)
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exGroupLines;
Tree1->Indent = 12;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(var_Items->InsertItem(h,TNoParam(),TVariant("Child 2")),TNoParam(),TVariant("SubChild 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
|
|
469
|
Does your control supports multiple lines tooltip
Tree1->HTMLPicture[L"pic1"] = TVariant("c:\\exontrol\\images\\zipdisk.gif");
Tree1->ToolTipDelay = 1;
Tree1->Columns->Add(L"tootip")->ToolTip = TVariant(String("<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, ") +
"icons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>");
|
|
468
|
How can I prevent highlighting the column from the cursor - point
Tree1->VisualAppearance->Add(1,TVariant(String("gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJ") +
"gEgI="));
Tree1->Background[Extreelib_tlb::BackgroundPartEnum::exCursorHoverColumn] = 0x1000000;
Tree1->Columns->Add(L"S")->Width = 32;
Tree1->Columns->Add(L"Level 1")->set_LevelKey(TVariant(1));
Tree1->Columns->Add(L"Level 2")->set_LevelKey(TVariant(1));
Tree1->Columns->Add(L"Level 3")->set_LevelKey(TVariant(1));
Tree1->Columns->Add(L"E1")->Width = 32;
Tree1->Columns->Add(L"E2")->Width = 32;
Tree1->Columns->Add(L"E3")->Width = 32;
Tree1->Columns->Add(L"E4")->Width = 32;
|
|
467
|
Is there any option to show the tooltip programmatically
// MouseMove event - Occurs when the user moves the mouse.
void __fastcall TForm1::Tree1MouseMove(TObject *Sender,short Button,short Shift,int X,int Y)
{
Tree1->ShowToolTip(PChar(Tree1->ItemFromPoint[-1,-1,c,hit]),TVariant(""),TVariant("8"),TVariant("8"),TNoParam());
}
Tree1->BeginUpdate();
Tree1->Columns->Add(L"Def");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("Item 1"));
var_Items->AddItem(TVariant("Item 2"));
var_Items->AddItem(TVariant("Item 3"));
Tree1->EndUpdate();
|
|
466
|
Is it possible to prevent changing the rows/items colors by selection
Tree1->SelBackMode = Extreelib_tlb::BackModeEnum::exTransparent;
Tree1->Columns->Add(L"HTML")->set_Def(Extreelib_tlb::DefColumnEnum::exCellCaptionFormat,TVariant(1));
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>."));
var_Items->set_SelectItem(var_Items->AddItem(TVariant("<font ;6>This</font> <b>is</b> another <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.")),true);
|
|
465
|
Is it possible to specify the cell's value but still want to display some formatted text instead the value
Tree1->BeginUpdate();
Tree1->MarkSearchColumn = false;
Tree1->Columns->Add(L"Value");
Tree1->Columns->Add(L"FormatCell");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant(1));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(12));
var_Items->set_FormatCell(TVariant(h),TVariant(1),L"currency(value)");
h = var_Items->AddItem(TVariant(TDateTime(2001,1,1).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2001,1,1).operator double()));
var_Items->set_CellCaptionFormat(TVariant(h),TVariant(1),Extreelib_tlb::CaptionFormatEnum::exHTML);
var_Items->set_FormatCell(TVariant(h),TVariant(1),L"longdate(value) replace '2001' with '<b>2001</b>'");
Tree1->EndUpdate();
|
|
464
|
How can I simulate displaying groups
Tree1->BeginUpdate();
Tree1->HasLines = Extreelib_tlb::HierarchyLineEnum::exNoLine;
Tree1->ScrollBySingleLine = true;
Tree1->MarkSearchColumn = false;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name");
var_Columns->Add(L"A");
var_Columns->Add(L"B");
var_Columns->Add(L"C");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Group 1"));
var_Items->set_CellHAlignment(TVariant(h),TVariant(0),Extreelib_tlb::AlignmentEnum::CenterAlignment);
var_Items->set_ItemDivider(h,0);
var_Items->set_ItemDividerLineAlignment(h,Extreelib_tlb::DividerAlignmentEnum::DividerBoth);
var_Items->set_ItemHeight(h,24);
var_Items->set_SortableItem(h,false);
long h1 = var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->set_CellCaption(TVariant(h1),TVariant(1),TVariant(1));
var_Items->set_CellCaption(TVariant(h1),TVariant(2),TVariant(2));
var_Items->set_CellCaption(TVariant(h1),TVariant(3),TVariant(3));
h1 = var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_CellCaption(TVariant(h1),TVariant(1),TVariant(4));
var_Items->set_CellCaption(TVariant(h1),TVariant(2),TVariant(5));
var_Items->set_CellCaption(TVariant(h1),TVariant(3),TVariant(6));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("Group 2"));
var_Items->set_CellHAlignment(TVariant(h),TVariant(0),Extreelib_tlb::AlignmentEnum::CenterAlignment);
var_Items->set_ItemDivider(h,0);
var_Items->set_ItemDividerLineAlignment(h,Extreelib_tlb::DividerAlignmentEnum::DividerBoth);
var_Items->set_ItemHeight(h,24);
var_Items->set_SortableItem(h,false);
h1 = var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->set_CellCaption(TVariant(h1),TVariant(1),TVariant(1));
var_Items->set_CellCaption(TVariant(h1),TVariant(2),TVariant(2));
var_Items->set_CellCaption(TVariant(h1),TVariant(3),TVariant(3));
h1 = var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_CellCaption(TVariant(h1),TVariant(1),TVariant(4));
var_Items->set_CellCaption(TVariant(h1),TVariant(2),TVariant(5));
var_Items->set_CellCaption(TVariant(h1),TVariant(3),TVariant(6));
var_Items->set_ExpandItem(h,true);
Tree1->EndUpdate();
|
|
463
|
How can I collapse all items
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Items");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(0,false);
Tree1->EndUpdate();
|
|
462
|
How can I expand all items
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Items");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
h = var_Items->AddItem(TVariant("Root 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(0,true);
Tree1->EndUpdate();
|
|
461
|
Can I use PNG images to display pictures in the control
Tree1->HTMLPicture[L"pic1"] = TVariant("c:\\exontrol\\images\\card.png");
Tree1->HeaderHeight = 48;
Tree1->Columns->Add(L"ColumnName")->HTMLCaption = L"<b>HTML</b> Column <img>pic1</img> Picture";
|
|
460
|
Is it possible to move an item from a parent to another
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Items");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("A"));
var_Items->AddItem(TVariant("B"));
var_Items->InsertItem(var_Items->AddItem(TVariant("C")),TVariant(""),TVariant("D"));
var_Items->SetParent(var_Items->get_FindItem(TVariant("D"),TVariant(0),TNoParam()),var_Items->get_FindItem(TVariant("A"),TVariant(0),TNoParam()));
Tree1->EndUpdate();
|
|
459
|
How can I change the identation for an item
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Items");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("A"));
var_Items->AddItem(TVariant("B"));
var_Items->InsertItem(var_Items->AddItem(TVariant("C")),TVariant(""),TVariant("D"));
var_Items->SetParent(var_Items->get_FindItem(TVariant("D"),TVariant(0),TNoParam()),0);
Tree1->EndUpdate();
|
|
458
|
How can I filter programatically using more columns
Tree1->BeginUpdate();
Tree1->MarkSearchColumn = false;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Car");
var_Columns->Add(L"Equipment");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant("Mazda"))),TVariant(1),TVariant("Air Bag"));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant("Toyota"))),TVariant(1),TVariant("Air Bag,Air condition"));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant("Ford"))),TVariant(1),TVariant("Air condition"));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant("Nissan"))),TVariant(1),TVariant("Air Bag,ABS,ESP"));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant("Mazda"))),TVariant(1),TVariant("Air Bag, ABS,ESP"));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant("Mazda"))),TVariant(1),TVariant("ABS,ESP"));
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->get_Item(TVariant("Car"));
var_Column->FilterType = Extreelib_tlb::FilterTypeEnum::exFilter;
var_Column->Filter = L"Mazda";
Extreelib_tlb::IColumnPtr var_Column1 = Tree1->Columns->get_Item(TVariant("Equipment"));
var_Column1->FilterType = Extreelib_tlb::FilterTypeEnum::exPattern;
var_Column1->Filter = L"*ABS*|*ESP*";
Tree1->ApplyFilter();
Tree1->EndUpdate();
|
|
457
|
Is it possible to colour a particular column, I mean the cell's foreground color
Tree1->BeginUpdate();
Extreelib_tlb::IConditionalFormatPtr var_ConditionalFormat = Tree1->ConditionalFormats->Add(L"1",TNoParam());
var_ConditionalFormat->ForeColor = RGB(255,0,0);
var_ConditionalFormat->ApplyTo = Extreelib_tlb::FormatApplyToEnum(0x1);
Tree1->MarkSearchColumn = false;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Column 1");
var_Columns->Add(L"Column 2");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(0))),TVariant(1),TVariant(1));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(2))),TVariant(1),TVariant(3));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(4))),TVariant(1),TVariant(5));
Tree1->EndUpdate();
|
|
456
|
Is it possible to colour a particular column for specified values
Tree1->BeginUpdate();
Extreelib_tlb::IConditionalFormatPtr var_ConditionalFormat = Tree1->ConditionalFormats->Add(L"int(%1) in (3,4,5)",TNoParam());
var_ConditionalFormat->BackColor = RGB(255,0,0);
var_ConditionalFormat->ApplyTo = Extreelib_tlb::FormatApplyToEnum(0x1);
Tree1->MarkSearchColumn = false;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Column 1");
var_Columns->Add(L"Column 2");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(0))),TVariant(1),TVariant(1));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(2))),TVariant(1),TVariant(3));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(4))),TVariant(1),TVariant(5));
Tree1->EndUpdate();
|
|
455
|
Is it possible to colour a particular column
Tree1->BeginUpdate();
Tree1->MarkSearchColumn = false;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Column 1");
var_Columns->Add(L"Column 2")->set_Def(Extreelib_tlb::DefColumnEnum::exCellBackColor,TVariant(255));
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(0))),TVariant(1),TVariant(1));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(2))),TVariant(1),TVariant(3));
var_Items->set_CellCaption(TVariant(var_Items->AddItem(TVariant(4))),TVariant(1),TVariant(5));
Tree1->EndUpdate();
|
|
454
|
How do i get all the children items that are under a certain parent Item handle
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"P");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
Extreelib_tlb::IItemsPtr var_Items1 = Tree1->Items;
long hChild = var_Items1->get_ItemChild(var_Items1->FirstVisibleItem);
OutputDebugString( PChar(var_Items1->get_CellCaption(TVariant(hChild),TVariant(0))) );
OutputDebugString( PChar(var_Items1->get_CellCaption(TVariant(var_Items1->get_NextSiblingItem(hChild)),TVariant(0))) );
Tree1->EndUpdate();
|
|
453
|
How can I get the caption of focused item
// SelectionChanged event - Fired after a new item has been selected.
void __fastcall TForm1::Tree1SelectionChanged(TObject *Sender)
{
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
OutputDebugString( L"Handle" );
OutputDebugString( PChar(var_Items->FocusItem) );
OutputDebugString( L"Caption" );
OutputDebugString( PChar(var_Items->get_CellCaption(TVariant(var_Items->FocusItem),TVariant(0))) );
}
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Items");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("R1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 1.1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 1.2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("R2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 2.1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 2.2"));
var_Items->set_ExpandItem(h,true);
Tree1->EndUpdate();
|
|
452
|
How can I get the caption of selected item
// SelectionChanged event - Fired after a new item has been selected.
void __fastcall TForm1::Tree1SelectionChanged(TObject *Sender)
{
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
OutputDebugString( L"Handle" );
OutputDebugString( PChar(var_Items->get_SelectedItem(0)) );
OutputDebugString( L"Caption" );
OutputDebugString( PChar(var_Items->get_CellCaption(TVariant(var_Items->get_SelectedItem(0)),TVariant(0))) );
}
Tree1->BeginUpdate();
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Tree1->Columns->Add(L"Items");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("R1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 1.1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 1.2"));
var_Items->set_ExpandItem(h,true);
h = var_Items->AddItem(TVariant("R2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 2.1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Cell 2.2"));
var_Items->set_ExpandItem(h,true);
Tree1->EndUpdate();
|
|
451
|
Can I display the cell's check box after the text
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Column");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellHasCheckBox,TVariant(true));
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellDrawPartsOrder,TVariant("caption,check"));
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->set_CellHasCheckBox(TVariant(var_Items->AddItem(TVariant("Caption 1"))),TVariant(0),true);
var_Items->set_CellHasCheckBox(TVariant(var_Items->AddItem(TVariant("Caption 2"))),TVariant(0),true);
|
|
450
|
Can I change the order of the parts in the cell, as checkbox after the text, and so on
Tree1->Images(TVariant(String("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="));
Tree1->Columns->Add(L"Column")->set_Def(Extreelib_tlb::DefColumnEnum::exCellDrawPartsOrder,TVariant("caption,check,icon,icons,picture"));
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Text"));
var_Items->set_CellImage(TVariant(h),TVariant(0),1);
var_Items->set_CellHasCheckBox(TVariant(h),TVariant(0),true);
|
|
449
|
Can I have an image displayed after the text. Can I get that effect without using HTML content
Tree1->Images(TVariant(String("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="));
Tree1->Columns->Add(L"Column")->set_Def(Extreelib_tlb::DefColumnEnum::exCellDrawPartsOrder,TVariant("caption,icon,check,icons,picture"));
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Text"));
var_Items->set_CellImage(TVariant(h),TVariant(0),1);
|
|
448
|
Does your control support RightToLeft property for RTL languages or right to left
Tree1->BeginUpdate();
Tree1->ScrollBars = Extreelib_tlb::ScrollBarsEnum::exDisableBoth;
Tree1->LinesAtRoot = Extreelib_tlb::LinesAtRootEnum::exLinesAtRoot;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"P1");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellHasCheckBox,TVariant(true));
var_Column->PartialCheck = true;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->set_ExpandItem(h,true);
Tree1->RightToLeft = true;
Tree1->EndUpdate();
|
|
447
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
Tree1->BeginUpdate();
Tree1->ScrollBars = Extreelib_tlb::ScrollBarsEnum::exDisableBoth;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"C1");
var_Columns->Add(L"C2");
var_Columns->Add(L"C3");
var_Columns->Add(L"C4");
var_Columns->Add(L"C5");
var_Columns->Add(L"C6");
var_Columns->Add(L"C7");
var_Columns->Add(L"C8");
Tree1->RightToLeft = true;
Tree1->EndUpdate();
|
|
446
|
How can I use the CASE statement (CASE usage)
Tree1->BeginUpdate();
Tree1->Columns->Add(L"Value")->Width = 24;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"CASE - statment");
var_Column->ComputedField = TVariant(String("%0 case (default:'not found';1:%0;2:2*%0;3:3*%0;4:4*%0;5:5*%0;7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen';14:'Fourt") +
"heen')");
var_Column->ToolTip = var_Column->ComputedField;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(1));
var_Items->AddItem(TVariant(2));
Tree1->EndUpdate();
|
|
445
|
How can I use the CASE statement (CASE usage)
Tree1->BeginUpdate();
Tree1->Columns->Add(L"Value")->Width = 24;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"CASE - statment");
var_Column->ComputedField = TVariant(String("%0 case (default:'not found';1:'One';2:'Two';3:'Three';4:'Four';5:'Five';7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen") +
"';14:'Fourtheen')");
var_Column->ToolTip = var_Column->ComputedField;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(1));
var_Items->AddItem(TVariant(2));
Tree1->EndUpdate();
|
|
444
|
I have seen the IN function but it returns -1 or 0. How can I display the value being found ( SWITCH usage )
Tree1->BeginUpdate();
Tree1->Columns->Add(L"Value")->Width = 24;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"SWITCH - statment");
var_Column->ComputedField = L"%0 switch ('not found', 1,2,3,4,5,7,8,9,11,13,14)";
var_Column->ToolTip = var_Column->ComputedField;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(1));
var_Items->AddItem(TVariant(2));
Tree1->EndUpdate();
|
|
443
|
I have a large collection of constant values and using or operator is a time consuming (IN usage). Is there any way to increase the speed to check if a value maches the collection
Tree1->BeginUpdate();
Tree1->Columns->Add(L"Value")->Width = 24;
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"IN - statment");
var_Column->ComputedField = L"%0 in (1,2,3,4,5,7,8,9,11,13,14) ? 'found' : ''";
var_Column->ToolTip = var_Column->ComputedField;
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(1));
var_Items->AddItem(TVariant(2));
Tree1->EndUpdate();
|
|
442
|
Is is possible to use HTML tags to display in the filter caption
Tree1->BeginUpdate();
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarCaption = L"This is a bit of text being displayed in the filter bar.";
Tree1->Columns->Add(L"");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("Item 1"));
var_Items->AddItem(TVariant("Item 2"));
var_Items->AddItem(TVariant("Item 3"));
Tree1->EndUpdate();
|
|
441
|
How can I find the number of items after filtering
Tree1->BeginUpdate();
Tree1->Columns->Add(L"");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant(""));
var_Items->set_CellCaption(TVariant(h),TVariant(0),TVariant(var_Items->VisibleItemCount));
Tree1->EndUpdate();
|
|
440
|
How can I change the filter caption
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptWords | Extreelib_tlb::FilterPromptEnum::exFilterPromptContainsAll;
Tree1->FilterBarPromptPattern = L"london robert";
Tree1->FilterBarCaption = L"<r>Found: ... ";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
439
|
While using the filter prompt is it is possible to use wild characters
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptPattern;
Tree1->FilterBarPromptPattern = L"lon* seat*";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
438
|
How can I list all items that contains any of specified words, not necessary at the beggining
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptStartWords | Extreelib_tlb::FilterPromptEnum::exFilterPromptContainsAny;
Tree1->FilterBarPromptPattern = L"london davolio";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
437
|
How can I list all items that contains any of specified words, not strings
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptWords | Extreelib_tlb::FilterPromptEnum::exFilterPromptContainsAny;
Tree1->FilterBarPromptPattern = L"london nancy";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
436
|
How can I list all items that contains all specified words, not strings
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptWords | Extreelib_tlb::FilterPromptEnum::exFilterPromptContainsAll;
Tree1->FilterBarPromptPattern = L"london robert";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
435
|
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptCaseSensitive | Extreelib_tlb::FilterPromptEnum::exFilterPromptContainsAny;
Tree1->FilterBarPromptPattern = L"Anne";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
434
|
Is it possible to list only items that ends with any of specified strings
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptEndWith;
Tree1->set_FilterBarPromptColumns(TVariant("0"));
Tree1->FilterBarPromptPattern = L"Fuller";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
433
|
Is it possible to list only items that ends with any of specified strings
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptEndWith;
Tree1->set_FilterBarPromptColumns(TVariant("0"));
Tree1->FilterBarPromptPattern = L"Fuller";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
432
|
Is it possible to list only items that starts with any of specified strings
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptStartWith;
Tree1->set_FilterBarPromptColumns(TVariant("0"));
Tree1->FilterBarPromptPattern = L"An M";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
431
|
Is it possible to list only items that starts with specified string
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptStartWith;
Tree1->set_FilterBarPromptColumns(TVariant("0"));
Tree1->FilterBarPromptPattern = L"A";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
430
|
How can I specify that the list should include any of the seqeunces in the pattern
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptContainsAny;
Tree1->FilterBarPromptPattern = L"london seattle";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
429
|
How can I specify that all sequences in the filter pattern must be included in the list
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptType = Extreelib_tlb::FilterPromptEnum::exFilterPromptContainsAll;
Tree1->FilterBarPromptPattern = L"london manager";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
428
|
How do I change at runtime the filter prompt
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPromptPattern = L"london manager";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
427
|
How do I specify to filter only a single column when using the filter prompt
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->set_FilterBarPromptColumns(TVariant("2,3"));
Tree1->FilterBarPromptPattern = L"london";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
426
|
How do I change the prompt or the caption being displayed in the filter bar
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Tree1->FilterBarPrompt = L"changed";
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Tree1->EndUpdate();
|
|
425
|
How do I enable the filter prompt feature
Tree1->BeginUpdate();
Tree1->ColumnAutoResize = true;
Tree1->ContinueColumnScroll = false;
Tree1->MarkSearchColumn = false;
Tree1->SearchColumnIndex = 1;
Tree1->FilterBarPromptVisible = true;
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Name")->Width = 96;
var_Columns->Add(L"Title")->Width = 96;
var_Columns->Add(L"City");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h0 = var_Items->AddItem(TVariant("Nancy Davolio"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Andrew Fuller"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Vice President, Sales"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Tacoma"));
var_Items->set_SelectItem(h0,true);
h0 = var_Items->AddItem(TVariant("Janet Leverling"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Kirkland"));
h0 = var_Items->AddItem(TVariant("Margaret Peacock"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Redmond"));
h0 = var_Items->AddItem(TVariant("Steven Buchanan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Manager"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Michael Suyama"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Robert King"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
h0 = var_Items->AddItem(TVariant("Laura Callahan"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Inside Sales Coordinator"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("Seattle"));
h0 = var_Items->AddItem(TVariant("Anne Dodsworth"));
var_Items->set_CellCaption(TVariant(h0),TVariant(1),TVariant("Sales Representative"));
var_Items->set_CellCaption(TVariant(h0),TVariant(2),TVariant("London"));
Tree1->EndUpdate();
|
|
424
|
I have an EBN file how can I apply different colors to it, so no need to create a new one
Tree1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Tree1->SelBackColor = Tree1->BackColor;
Tree1->SelForeColor = Tree1->ForeColor;
Tree1->HasLines = Extreelib_tlb::HierarchyLineEnum::exNoLine;
Tree1->Columns->Add(L"Default");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
long hC = var_Items->InsertItem(h,TNoParam(),TVariant("Default"));
var_Items->set_ItemBackColor(hC,0x1000000);
var_Items->set_ItemHeight(var_Items->InsertItem(h,TNoParam(),TVariant("")),6);
hC = var_Items->InsertItem(h,TNoParam(),TVariant("Light Green"));
var_Items->set_ItemBackColor(hC,0x100ff00);
var_Items->set_ItemHeight(var_Items->InsertItem(h,TNoParam(),TVariant("")),6);
hC = var_Items->InsertItem(h,TNoParam(),TVariant("Dark Green"));
var_Items->set_ItemBackColor(hC,0x1007f00);
var_Items->set_ItemHeight(var_Items->InsertItem(h,TNoParam(),TVariant("")),6);
hC = var_Items->InsertItem(h,TNoParam(),TVariant("Magenta"));
var_Items->set_ItemBackColor(hC,0x1ff7fff);
var_Items->set_ItemHeight(var_Items->InsertItem(h,TNoParam(),TVariant("")),6);
hC = var_Items->InsertItem(h,TNoParam(),TVariant("Yellow"));
var_Items->set_ItemBackColor(hC,0x17fffff);
var_Items->set_ItemHeight(var_Items->InsertItem(h,TNoParam(),TVariant("")),6);
var_Items->set_ExpandItem(h,true);
|
|
423
|
How can I change the foreground color for a particular column
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Column 1");
var_Columns->Add(L"Column 2")->set_Def(Extreelib_tlb::DefColumnEnum::exHeaderForeColor,TVariant(8439039));
var_Columns->Add(L"Column 3");
|
|
422
|
How can I change the background color for a particular column
Extreelib_tlb::IColumnsPtr var_Columns = Tree1->Columns;
var_Columns->Add(L"Column 1");
var_Columns->Add(L"Column 2")->set_Def(Extreelib_tlb::DefColumnEnum::exHeaderBackColor,TVariant(8439039));
var_Columns->Add(L"Column 3");
|
|
421
|
How can I display the column using currency format and enlarge the font for certain values
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Currency");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellCaptionFormat,TVariant(1));
var_Column->FormatColumn = L"len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("1.23"));
var_Items->AddItem(TVariant("2.34"));
var_Items->AddItem(TVariant("9.94"));
var_Items->AddItem(TVariant("11.94"));
var_Items->AddItem(TVariant("1000"));
|
|
420
|
How can I highlight only parts of the cells
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellCaptionFormat,TVariant(1));
var_Column->FormatColumn = L"value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
|
|
419
|
How can I get the number of occurrences of a specified string in the cell
Tree1->Columns->Add(L"");
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"occurrences");
var_Column->ComputedField = L"lower(%0) count 'o'";
var_Column->FormatColumn = L"'contains ' + value + ' of \\'o\\' chars'";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1 oooof the root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 3"));
var_Items->set_ExpandItem(h,true);
|
|
418
|
How can I display dates in my format
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Date");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellCaptionFormat,TVariant(1));
var_Column->FormatColumn = L"'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,21).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,22).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,13).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,24).operator double()));
|
|
417
|
How can I display dates in short format
Tree1->Columns->Add(L"Date")->FormatColumn = L"shortdate(value)";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,1).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,2).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,3).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,4).operator double()));
|
|
416
|
How can I display dates in long format
Tree1->Columns->Add(L"Date")->FormatColumn = L"longdate(value)";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,1).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,2).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,3).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,4).operator double()));
|
|
415
|
How can I display only the right part of the cell
Tree1->Columns->Add(L"");
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Right");
var_Column->ComputedField = L"%0 right 2";
var_Column->FormatColumn = L"'\"' + value + '\"'";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("SChild 3"));
var_Items->set_ExpandItem(h,true);
|
|
414
|
How can I display only the left part of the cell
Tree1->Columns->Add(L"");
Tree1->Columns->Add(L"Left")->ComputedField = L"%0 left 2";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant("Root"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 1"));
var_Items->InsertItem(h,TNoParam(),TVariant("Child 2"));
var_Items->InsertItem(h,TNoParam(),TVariant("SChild 3"));
var_Items->set_ExpandItem(h,true);
|
|
413
|
How can I display true or false instead 0 and -1
Tree1->Columns->Add(L"Boolean")->FormatColumn = L"value != 0 ? 'true' : 'false'";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(true));
var_Items->AddItem(TVariant(false));
var_Items->AddItem(TVariant(true));
var_Items->AddItem(TVariant(0));
var_Items->AddItem(TVariant(1));
|
|
412
|
How can I display icons or images instead numbers
Tree1->Images(TVariant(String("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="));
Extreelib_tlb::IColumnPtr var_Column = Tree1->Columns->Add(L"Icons");
var_Column->set_Def(Extreelib_tlb::DefColumnEnum::exCellCaptionFormat,TVariant(1));
var_Column->FormatColumn = L"'The cell displays the icon <img>'+value+'</img> instead ' + value";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(1));
var_Items->AddItem(TVariant(2));
var_Items->AddItem(TVariant(3));
|
|
411
|
How can I display the column using currency
Tree1->Columns->Add(L"Currency")->FormatColumn = L"currency(dbl(value))";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("1.23"));
var_Items->AddItem(TVariant("2.34"));
var_Items->AddItem(TVariant("0"));
var_Items->AddItem(TVariant(5));
var_Items->AddItem(TVariant("10000.99"));
|
|
410
|
How can I display the currency only for not empty cells
Tree1->Columns->Add(L"Number");
Tree1->Columns->Add(L"Currency")->ComputedField = L"len(%0) ? currency(dbl(%0)) : ''";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant("1.23"));
var_Items->AddItem(TVariant("2.34"));
var_Items->AddItem(TVariant("0"));
var_Items->set_ItemBackColor(var_Items->AddItem(TNoParam()),RGB(255,128,128));
var_Items->AddItem(TVariant("10000.99"));
|
|
409
|
Is there a function to display the number of days between two date including the number of hours
Tree1->Columns->Add(L"Start")->Width = 32;
Tree1->Columns->Add(L"End");
Tree1->Columns->Add(L"Duration")->ComputedField = TVariant(String("2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : ") +
"'') + =:3 + ' hour(s)' : '' )");
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant(TDateTime(2001,1,11).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2001,1,14).operator double()));
h = var_Items->AddItem(TVariant(TDateTime(2002,2,22,12,00,00,0).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2002,3,14,13,00,00,0).operator double()));
h = var_Items->AddItem(TVariant(TDateTime(2003,3,13).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2003,4,11,11,00,00,0).operator double()));
|
|
408
|
Is there a function to display the number of days between two date including the number of hours
Tree1->Columns->Add(L"Start");
Tree1->Columns->Add(L"End");
Tree1->Columns->Add(L"Duration")->ComputedField = L"\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant(TDateTime(2001,1,11).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2001,1,14,23,00,00,0).operator double()));
h = var_Items->AddItem(TVariant(TDateTime(2002,2,22,12,00,00,0).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2002,3,14,13,00,00,0).operator double()));
h = var_Items->AddItem(TVariant(TDateTime(2003,3,13).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2003,4,11,11,00,00,0).operator double()));
|
|
407
|
How can I display the number of days between two dates
Tree1->Columns->Add(L"Start");
Tree1->Columns->Add(L"End");
Tree1->Columns->Add(L"Duration")->ComputedField = L"(date(%1)-date(%0)) + ' days'";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
long h = var_Items->AddItem(TVariant(TDateTime(2001,1,11).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2001,1,14).operator double()));
h = var_Items->AddItem(TVariant(TDateTime(2002,2,22).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2002,3,14).operator double()));
h = var_Items->AddItem(TVariant(TDateTime(2003,3,13).operator double()));
var_Items->set_CellCaption(TVariant(h),TVariant(1),TVariant(TDateTime(2003,4,11).operator double()));
|
|
406
|
How can I get second part of the date
Tree1->Columns->Add(L"Date");
Tree1->Columns->Add(L"Second")->ComputedField = L"sec(date(%0))";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,11,10,10,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,22,11,01,22,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,13,12,23,01,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,14,13,11,59,0).operator double()));
|
|
405
|
How can I get minute part of the date
Tree1->Columns->Add(L"Date");
Tree1->Columns->Add(L"Minute")->ComputedField = L"min(date(%0))";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,11,10,10,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,22,11,01,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,13,12,23,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,14,13,11,00,0).operator double()));
|
|
404
|
How can I check the hour part only so I know it was afternoon
Tree1->ConditionalFormats->Add(L"hour(%0)>=12",TNoParam())->Bold = true;
Tree1->Columns->Add(L"Date");
Tree1->Columns->Add(L"Hour")->ComputedField = L"hour(%0)";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,11,10,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,22,11,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,13,12,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,14,13,00,00,0).operator double()));
|
|
403
|
What about a function to get the day in the week, or days since Sunday
Tree1->Columns->Add(L"Date");
Tree1->Columns->Add(L"WeekDay")->ComputedField = L"weekday(%0)";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,11,10,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,22,11,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,13,12,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,14,13,00,00,0).operator double()));
|
|
402
|
Is there any function to get the day of the year or number of days since January 1st
Tree1->Columns->Add(L"Date");
Tree1->Columns->Add(L"Day since January 1st")->ComputedField = L"yearday(%0)";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,11,10,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,22,11,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,13,12,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,14,13,00,00,0).operator double()));
|
|
401
|
How can I display only the day of the date
Tree1->Columns->Add(L"Date");
Tree1->Columns->Add(L"Day")->ComputedField = L"day(%0)";
Extreelib_tlb::IItemsPtr var_Items = Tree1->Items;
var_Items->AddItem(TVariant(TDateTime(2001,1,11,10,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2002,2,22,11,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2003,3,13,12,00,00,0).operator double()));
var_Items->AddItem(TVariant(TDateTime(2004,4,14,13,00,00,0).operator double()));
|